package mdb.com.vn.model;
/**
 * @author tu.dod
 *
 */
import java.io.Serializable;

import javax.persistence.*;

import java.math.BigDecimal;
import java.util.Date;


/**
 * The persistent class for the IFTB_AVG_ACCOUNT_SME database table.
 * 
 */
@Entity
@Table(name="IFTB_SME_SMS")
@NamedQueries({
	@NamedQuery(name = "SmeSms.findByStatus", query = "SELECT c FROM SmeSms c WHERE c.status = :status"),
	@NamedQuery(name = "SmeSms.findByDateStatus", query = "SELECT c FROM SmeSms c WHERE c.status = :status AND c.processDate = :processDate"),
	@NamedQuery(name = "SmeSms.findByPDateStatus", query = "SELECT c FROM SmeSms c WHERE c.gcif = :gcif AND c.processDate = :processDate")
})
public class SmeSms implements Serializable {
	private static final long serialVersionUID = 1L;
	
	@Id
	private long id;
	
	@Column(name="CLO_AVG_BAL")
	private BigDecimal cloAvgBal;

	@Column(name="CREATED_BY")
	private String createdBy;

	@Column(name="FIN_CYCLE")
	private String finCycle;

	@Column(name="GCIF")
	private String gcif;
	
	@Column(name="PHONE")
	private String phoneNum;

	@Column(name="LKD_NUM")
	private int lkdNum;

	@Column(name="PERIOD_CODE")
	private String periodCode;

	@Temporal(TemporalType.DATE)
	@Column(name="PROCESS_DATE")
	private Date processDate;

	@Column(name="STATUS")
	private String status;
	
	@Column(name="BRANCH_CODE")
	private String branchCode;
	
	@Column(name="UPDATED_BY")
	private String updatedBy;

	@Temporal(TemporalType.DATE)
	@Column(name="UPDATED_DATE")
	private Date updatedDate;

	public SmeSms() {
		// TODO Auto-generated constructor stub
	}

	
	/**
	 * @return the branchCode
	 */
	public String getBranchCode() {
		return branchCode;
	}


	/**
	 * @param branchCode the branchCode to set
	 */
	public void setBranchCode(String branchCode) {
		this.branchCode = branchCode;
	}


	/**
	 * @return the updatedBy
	 */
	public String getUpdatedBy() {
		return updatedBy;
	}


	/**
	 * @param updatedBy the updatedBy to set
	 */
	public void setUpdatedBy(String updatedBy) {
		this.updatedBy = updatedBy;
	}


	/**
	 * @return the updatedDate
	 */
	public Date getUpdatedDate() {
		return updatedDate;
	}


	/**
	 * @param updatedDate the updatedDate to set
	 */
	public void setUpdatedDate(Date updatedDate) {
		this.updatedDate = updatedDate;
	}


	public BigDecimal getCloAvgBal() {
		return this.cloAvgBal;
	}

	public void setCloAvgBal(BigDecimal cloAvgBal) {
		this.cloAvgBal = cloAvgBal;
	}

	public String getCreatedBy() {
		return this.createdBy;
	}

	public void setCreatedBy(String createdBy) {
		this.createdBy = createdBy;
	}

	public String getFinCycle() {
		return this.finCycle;
	}

	public void setFinCycle(String finCycle) {
		this.finCycle = finCycle;
	}

	public String getGcif() {
		return this.gcif;
	}

	public void setGcif(String gcif) {
		this.gcif = gcif;
	}

	public int getLkdNum() {
		return this.lkdNum;
	}

	public void setLkdNum(int lkdNum) {
		this.lkdNum = lkdNum;
	}

	public String getPeriodCode() {
		return this.periodCode;
	}

	public void setPeriodCode(String periodCode) {
		this.periodCode = periodCode;
	}

	public Date getProcessDate() {
		return this.processDate;
	}

	public void setProcessDate(Date processDate) {
		this.processDate = processDate;
	}

	public String getStatus() {
		return this.status;
	}

	public void setStatus(String status) {
		this.status = status;
	}

	/**
	 * @return the id
	 */
	public long getId() {
		return id;
	}

	/**
	 * @param id the id to set
	 */
	public void setId(long id) {
		this.id = id;
	}

	public String getPhoneNum() {
		return phoneNum;
	}

	public void setPhoneNum(String phoneNum) {
		this.phoneNum = phoneNum;
	}
	

}